Skip to main content
Version: 4.2.2

SQL Query and Select TOP

Grid Designer provides the user with the options 'Query' and 'Select TOP' to be used when needed. Next, we will detail the benefits of these options in the report for the user.

SQL Query​

For users with advanced SQL skills, the 'Query' option is available. It reveals the SQL statement that the dR View is going to execute against the data source. Please note that this feature is only applicable to SQL connections.

Steps to View the Query:​

  1. Open Grid Designer.
  2. Create a new report or open an existing one.
  3. Click on the "Query" icon.

Select TOP​

The option 'Select TOP' applies when it is not necessary to visualize all the data in Grid Designer. Keep in mind that using 'Select TOP 0' can retrieve all available data. Always check your selection to avoid unnecessary data retrieval.

Steps to Apply the Select TOP:​

  1. Open Grid Designer.
  2. Create a new report or open an existing one.
  3. Click on the "Home" tab.
  4. Click on the "Select TOP" icon.